Report Status Report Special Project CONFIDENTIAL December 18, 1985 PROPOSED BUDGET -- SPECIAL PROJECT This report outlines the estimated costs for carrying out the special project. Due to the nature of the project, general expenses are projected to increase 14% monthly. Expenses for the first month will be higher than we had originally expected. monthly increases in expenses do not include my travel costs; those will be paid for out of the department's travel budget, as we discussed. Performance reviews to be conducted this spring will increase salary expenditures 15% in April. Next week I will submit a report on the profit possibilities for the project, covering worst case, best case, and what we actually expect given the information we have to date. I will submit updates to this report each month as the project progresses. By the end of April we should have a good idea whether or not this project will result in a profitable venture. If the possibilities don't look good at that point, we can cut the project short. Summary Budget Salaries /$4,200 /$4,200 /$4,200 3$4,830 $D$2*1.15 3$4,830 $D$2*1.15 3$4,830 $D$2*1.15 Expenses $1,500 $1,710 B3 * 1.14 $1,949 C3 * 1.14 $2,222 D3 * 1.14 $2,533 E3 * 1.14 $2,888 F3 * 1.14 Totals /$5,700 B2 + B3 3$5,910 C2 + C3 @Ia2$6,149 D2 + D3 3$7,052 E2 + E3 Dcs2$7,363 F2 + F3 3$7,718 G2 + G3 #GRAPH @Costs ; Causes graph to update automatically when numbers are changed Costs ; Causes j Costs 5000 Salaries 4000 3000 Expenses 2000 1000 0 Jan F0e0b0 M0a0r0 A0p0r0 M0a0y0 J0u0n0 @DrawGraph(Budget.B2:Budget.G3,#ROW,#BAR,,,) Costs (#s$( hBs$( PFs$( Ns$(